<?php
require_once '_portal.php';
/*
postData:
{
"callsign": "CES3344",
"company": "其他",
"date": "2021-10-5",
"time": "14:15:41",
"frequency": "119.425",
"seat": "TM06",
"controllerA": {
"number": 2016039,
"name": "晁绵博",
"clientName": "晁绵博",
"clientOffice": "管制二室",
"clientGroup": "A3"
},
"controllerB": {
"number": 2004017,
"name": "陈虹宇",
"clientName":
"陈虹宇",
"clientOffice": "其他",
"clientGroup": "其他"
},
"type": "通播代码",
"multiple": "是",
"details": "wer rewrewrewrwerwerwerw"
}
 */
$sql = "INSERT INTO `2kt_rectify_record`(`number`, `callsign`, `company`, `eventTime`, `seat`, `frequency`, `controllerName`, `controllerNumber`, `controllerGroup`, `controllerOffice`, `coordinatorName`, `coordinatorNumber`, `coordinatorGroup`, `coordinatorOffice`, `errorType`, `multTimes`, `details`, `updateTime`) VALUES (null,'{$post->callsign}','{$post->company}','{$post->date} {$post->time}','{$post->seat}','{$post->frequency}','{$post->controllerA->name}','{$post->controllerA->number}','{$post->controllerA->clientGroup}','{$post->controllerA->clientOffice}','{$post->controllerB->name}','{$post->controllerB->number}','{$post->controllerB->clientGroup}','{$post->controllerB->clientOffice}','{$post->type}','{$post->multiple}','{$post->details}',null)";
exec_sql($sql);
output(['sql' => $sql]);